This assignment is for ETC5521 Assignment 1 by Team Lorikeet comprising of Aryan Jain and Emily Sheehan.
Measles is a highly infectious disease caused by the Measles virus. It can lead to pneumonia, infections of the middle ear, swelling of the brain and death.
A vaccine exists to prevent the onset of measles as there is no treatment. The vaccine involves the injection of attenuated measles antigens that stimulate the production of antibodies and memory cells, providing long-term protection against the virus. When administered properly, the vaccine is 90.5% effective within 72 hours of exposure (Barrabeig et al., 2011).
Unfortunately there is a growing number of individuals refusing vaccination, particularly in the US (Phadke et al., 2016). In Texas, the number of unvaccinated children attaining exemptions to attend school has increased by 28 times since 2003 (Sinclair et al., 2019). This has led to several outbreaks of vaccine preventable diseases, such as Measles. If this trend continues, there could be calamitous consequences.
This paper hopes to understand the reasons for vaccine refusal and determine whether there is a relationship between socio-economic status and vaccination rate. To analyse the relationship a dataset has been scraped from WSJ github repository. Although every precaution has been taken to ensure accurate figures have been calculated, some of the MMR rates, overall vaccination rates and school types were missing from the original dataset. The missing data was identified using naniar, and removed to reduce the impact on the figures calculated.
PERHAPS EXPLAIN DATA SOURCES IN MORE DETAIL
The data comprises of vaccination rates for 46,412 schools in 32 U.S states and was retrieved from The Wall Street Journal. The variables include; the school academic year, the school’s state, city, county, district, name, type, enrollment, MMR (measles, mumps and rubella) vaccination rate, overall vaccination rate, latitude, longitude and the percentage of students exempted from vaccinations due to personal, religious or medical reasons.
The data was collected in the 2017-18 school year for 11 states and 2018-19 school year for the remaining 21 states. The state health departments provided the vaccination data and the National Center for Education Statistic’s provided the school location, which was matched against the school name. In the case that there was no match, the school’s location was found with Google Maps API.
The individual state dataset was scraped from WSJ github repository and combined with the existing measles dataset with left_join to extract the longitude and latitude variables from it. Various functions from the rvest package were used to scrape the data including read_html and html_table.
Primary Question: Does Measles vaccination rate improve with better socio-economic conditions?
Secondary Questions:
The data was filtered to remove missing school type, overall vaccination rate and MMR rate. It was grouped by type and the average MMR vaccination rate and overall vaccination rate was calculated using the mean function. The tibble generated was named school_type_average. Then, the average MMR rates from the school_type_average tibble were plotted. The rates were annotated accordingly to draw attention to the difference between the MMR vaccination rate for each school type.
Interestingly enough, the overall vaccination rate and the MMR vaccination rate was the highest in public schools when compared to the rates in Kindergartens and private schools. This is consistent with findings from a study conducted by Shaw (2014) where it was found that private schools have higher rates of exemptions for immunisations than public schools.
The school_type_average was tabulated to compare the overall vaccination rate and MMR vaccination rate. Then, both rates were plotted according to school type.
| Type | Average MMR Vaccination Rate | Average Overall Vaccination Rate |
|---|---|---|
| Kindergarten | 94.2% | 88.0% |
| Private | 93.2% | 91.4% |
| Public | 95.9% | 94.5% |
When comparing the vaccination
NOTE - I have filled with the colours to match, but i dont know if that looks any good so we can change!
| State | MMR | PCI |
|---|---|---|
| Illinois | 97.39% | $56,839 |
| Pennsylvania | 96.89% | $56,225 |
| Utah | 95.04% | $46,320 |
| Colorado | 94.09% | $58,456 |
| New York | 93.45% | $68,668 |
| State | MMR | PCI |
|---|---|---|
| Massachusetts | 57.68% | $71,683 |
| Connecticut | 71.44% | $76,456 |
| Arizona | 74.56% | $44,329 |
| Montana | 76.20% | $47,538 |
| Washington | 79.45% | $62,026 |
| State | Overall | PCI |
|---|---|---|
| North Carolina | 96.779% | $46,117 |
| Tennessee | 95.023% | $46,900 |
| Florida | 92.487% | $50,070 |
| Michigan | 91.809% | $48,423 |
| Oregon | 90.265% | $50,843 |
| State | Overall | PCI |
|---|---|---|
| Washington | 75.238% | $62,026 |
| Oklahoma | 76.858% | $46,233 |
| Idaho | 81.036% | $43,901 |
| Iowa | 81.275% | $50,124 |
| Ohio | 82.113% | $48,739 |
https://github.com/TaxFoundation/facts-and-figures
measles definition - https://www.health.gov.au/health-topics/measles#what-is-measles
how vaccine works - https://www.health.qld.gov.au/news-events/news/what-is-measles-why-vaccinate#:~:text=The%20measles%20vaccine%20contains%20a,is%20better%20prepared%20to%20respond.
why people arent vaccinating - Cockcroft, A., Usman, M. U., Nyamucherera, O. F., Emori, H., Duke, B., Umar, N. A., & Andersson, N. (2014). Why children are not vaccinated against measles: a cross-sectional study in two Nigerian States. Archives of Public Health = Archives Belges de Sante Publique, 72(1), 48.
effectiveness stat - Barrabeig, I., Rovira, A., Rius, C., Muñoz, P., Soldevila, N., Batalla, J., & Domínguez, A. (2011). Effectiveness of measles vaccination for control of exposed children. The Pediatric Infectious Disease Journal, 30(1), 78–80.
growing number of refusal - Phadke, V. K., Bednarczyk, R. A., Salmon, D. A., & Omer, S. B. (2016). Association Between Vaccine Refusal and Vaccine-Preventable Diseases in the United States: A Review of Measles and Pertussis. JAMA: The Journal of the American Medical Association, 315(11), 1149–1158.
28 times - Sinclair, D. R., Grefenstette, J. J., Krauland, M. G., Galloway, D. D., Frankeny, R. J., Travis, C., Burke, D. S., & Roberts, M. S. (2019). Forecasted Size of Measles Outbreaks Associated With Vaccination Exemptions for Schoolchildren. JAMA Network Open, 2(8), e199768.
public higher than private - Shaw, J., Tserenpuntsag, B., McNutt, L.-A., & Halsey, N. (2014). United States private schools have higher rates of exemptions to school immunization requirements than public schools. The Journal of Pediatrics, 165(1), 129–133.